JDesignerPro by BulletProof Add Search Panel
[Back]



The Add Search Panel screen allows you to choose the elements by which to order searches on your forms. What you are building here is a pull down menu. This pull down will have a list of columns that can be searched. This panel is optional. To skip it, simply press the Add Result List tab.

The steps include:

  1. Double-click a column in the list. A default list of search terms will appear.
  2. If desired, change the Description in Pulldown to something other than the column name.
  3. You may add search terms and their corresponding SQL values in the table. The left side of the table is for the description of the matches that will appear when the selected column is chosen from the pull down. The right side of the table is for the actual SQL equivalent of the description.

    For example, the "Matching Descriptions" side might say "Greater Than" and in the "Values" (right hand) side of the table is ">", the corresponding SQL symbol. If you are unfamiliar with SQL, use the default values.

    You may not want to allow search terms to be entered. Another type of search pull-down list includes set values. For example you might have a column named Status. In the Matching values table you could have Active, Inactive, Pending. The corresponding SQL terms might be ='A', ='I', ='P'. Where A, I and P are the actual values in the table which determine a user's status.

  4. The Constant entry required choice determines whether the user will have a field in which to type a search term. Each column you select has a separate setting for this.
  5. The Make this the intial choice field determines which column will appear first in the search pull down.
  6. If you would like your search items to come from one of your database tables then switch the Values come from pulldown to Database table/column. Now you can choose a table and the corresponding column to show in the pulldown along with the column that will be used to select data when a search is done. The selections are done against the currently selected column from the list of columns on the left hand side of the screen.
Press the Reset button if you want to undo all your selections and changes. Once you have setup all your searchable columns, press Accept.

Now press the Add result List tab.


[Back]